package com.personnalManagerSystem.mapper;

import com.personnalManagerSystem.model.CompanyIncome;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Update;
import org.springframework.web.bind.annotation.RequestParam;

import java.math.BigDecimal;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author liqing
 * @since 2022-04-09
 */
public interface CompanyIncomeMapper extends BaseMapper<CompanyIncome> {
    @Update("\n" +
            "update company_income  set  company_profit= income_money-expenditure_money where company_income_id =#{companyIncomeId}")
    Boolean getCompanyProfit(@RequestParam("companyIncomeId")Long id);
}
